Pandas Profiling Report

Dataset statistics

Number of variables	16
Number of observations	197428
Missing cells	56061
Missing cells (%)	1.8%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	24.1 MiB
Average record size in memory	128.0 B

Variable types

Numeric	13
Categorical	3

Alerts

`created_at` has a high cardinality: 180985 distinct values	High cardinality
`actual_delivery_time` has a high cardinality: 178110 distinct values	High cardinality
`store_primary_category` has a high cardinality: 74 distinct values	High cardinality
`order_protocol` is highly overall correlated with `estimated_order_place_duration`	High correlation
`total_items` is highly overall correlated with `subtotal` and 2 other fields	High correlation
`subtotal` is highly overall correlated with `total_items` and 2 other fields	High correlation
`num_distinct_items` is highly overall correlated with `total_items` and 2 other fields	High correlation
`min_item_price` is highly overall correlated with `total_items` and 1 other fields	High correlation
`max_item_price` is highly overall correlated with `subtotal`	High correlation
`total_onshift_dashers` is highly overall correlated with `total_busy_dashers` and 1 other fields	High correlation
`total_busy_dashers` is highly overall correlated with `total_onshift_dashers` and 1 other fields	High correlation
`total_outstanding_orders` is highly overall correlated with `total_onshift_dashers` and 1 other fields	High correlation
`estimated_order_place_duration` is highly overall correlated with `order_protocol`	High correlation
`store_primary_category` has 4760 (2.4%) missing values	Missing
`total_onshift_dashers` has 16262 (8.2%) missing values	Missing
`total_busy_dashers` has 16262 (8.2%) missing values	Missing
`total_outstanding_orders` has 16262 (8.2%) missing values	Missing
`total_items` is highly skewed (γ1 = 21.41382417)	Skewed
`created_at` is uniformly distributed	Uniform
`actual_delivery_time` is uniformly distributed	Uniform
`min_item_price` has 2539 (1.3%) zeros	Zeros
`total_onshift_dashers` has 3615 (1.8%) zeros	Zeros
`total_busy_dashers` has 4171 (2.1%) zeros	Zeros
`total_outstanding_orders` has 4111 (2.1%) zeros	Zeros

Reproduction

Analysis started	2022-12-28 08:23:16.579813
Analysis finished	2022-12-28 08:24:01.124950
Duration	44.55 seconds
Software version	pandas-profiling vv3.6.1
Download configuration	config.json

market_id
Real number (ℝ)

Distinct	6
Distinct (%)	< 0.1%
Missing	987
Missing (%)	0.5%
Infinite	0
Infinite (%)	0.0%
Mean	2.9787061

Minimum	1
Maximum	6
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.5 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	3
Q3	4
95-th percentile	6
Maximum	6
Range	5
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.5248667
Coefficient of variation (CV)	0.51192252
Kurtosis	-0.93810124
Mean	2.9787061
Median Absolute Deviation (MAD)	1
Skewness	0.36120013
Sum	585140
Variance	2.3252185
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
2	55058	27.9%
4	47599	24.1%
1	38037	19.3%
3	23297	11.8%
5	18000	9.1%
6	14450	7.3%
(Missing)	987	0.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	38037	19.3%
2	55058	27.9%
3	23297	11.8%
4	47599	24.1%
5	18000	9.1%
6	14450	7.3%

Value	Count	Frequency (%)
6	14450	7.3%
5	18000	9.1%
4	47599	24.1%
3	23297	11.8%
2	55058	27.9%
1	38037	19.3%

created_at
Categorical

HIGH CARDINALITY UNIFORM

Distinct	180985
Distinct (%)	91.7%
Missing	0
Missing (%)	0.0%
Memory size	1.5 MiB

2015-02-11 19:50:43	6
2015-01-24 01:56:33	6
2015-02-16 01:48:11	5
2015-02-08 02:20:03	5
2015-02-11 19:51:06	5
Other values (180980)	197401

Length

Max length	19
Median length	19
Mean length	19
Min length	19

Characters and Unicode

Total characters	3751132
Distinct characters	13
Distinct categories	4 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	165374 ?
Unique (%)	83.8%

Sample

1st row	2015-02-06 22:24:17
2nd row	2015-02-10 21:49:25
3rd row	2015-01-22 20:39:28
4th row	2015-02-03 21:21:45
5th row	2015-02-15 02:40:36

Common Values

Value	Count	Frequency (%)
2015-02-11 19:50:43	6	< 0.1%
2015-01-24 01:56:33	6	< 0.1%
2015-02-16 01:48:11	5	< 0.1%
2015-02-08 02:20:03	5	< 0.1%
2015-02-11 19:51:06	5	< 0.1%
2015-02-11 19:50:41	5	< 0.1%
2015-01-31 01:41:10	5	< 0.1%
2015-01-31 02:16:03	4	< 0.1%
2015-02-16 01:47:34	4	< 0.1%
2015-02-03 02:04:13	4	< 0.1%
Other values (180975)	197379	> 99.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2015-02-07	9149	2.3%
2015-02-15	9087	2.3%
2015-02-14	9016	2.3%
2015-02-08	8874	2.2%
2015-01-24	8230	2.1%
2015-01-31	8146	2.1%
2015-01-25	7934	2.0%
2015-02-16	7932	2.0%
2015-02-01	7724	2.0%
2015-02-13	7383	1.9%
Other values (46097)	311381	78.9%

Most occurring characters

Value	Count	Frequency (%)
0	733984	19.6%
2	595423	15.9%
1	523163	13.9%
-	394856	10.5%
:	394856	10.5%
5	334468	8.9%
	197428	5.3%
3	175161	4.7%
4	144084	3.8%
9	66680	1.8%
Other values (3)	191029	5.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2763992	73.7%
Dash Punctuation	394856	10.5%
Other Punctuation	394856	10.5%
Space Separator	197428	5.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	733984	26.6%
2	595423	21.5%
1	523163	18.9%
5	334468	12.1%
3	175161	6.3%
4	144084	5.2%
9	66680	2.4%
7	64293	2.3%
6	63494	2.3%
8	63242	2.3%

Dash Punctuation

Value	Count	Frequency (%)
-	394856	100.0%

Other Punctuation

Value	Count	Frequency (%)
:	394856	100.0%

Space Separator

Value	Count	Frequency (%)
	197428	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	3751132	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	733984	19.6%
2	595423	15.9%
1	523163	13.9%
-	394856	10.5%
:	394856	10.5%
5	334468	8.9%
	197428	5.3%
3	175161	4.7%
4	144084	3.8%
9	66680	1.8%
Other values (3)	191029	5.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3751132	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	733984	19.6%
2	595423	15.9%
1	523163	13.9%
-	394856	10.5%
:	394856	10.5%
5	334468	8.9%
	197428	5.3%
3	175161	4.7%
4	144084	3.8%
9	66680	1.8%
Other values (3)	191029	5.1%

actual_delivery_time
Categorical

HIGH CARDINALITY UNIFORM

Distinct	178110
Distinct (%)	90.2%
Missing	7
Missing (%)	< 0.1%
Memory size	1.5 MiB

2015-02-11 20:40:45	5
2015-02-16 03:51:49	5
2015-02-01 03:44:13	5
2015-01-24 03:41:03	5
2015-02-12 03:14:14	5
Other values (178105)	197396

Length

Max length	19
Median length	19
Mean length	19
Min length	19

Characters and Unicode

Total characters	3750999
Distinct characters	13
Distinct categories	4 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	160456 ?
Unique (%)	81.3%

Sample

1st row	2015-02-06 23:27:16
2nd row	2015-02-10 22:56:29
3rd row	2015-01-22 21:09:09
4th row	2015-02-03 22:13:00
5th row	2015-02-15 03:20:26

Common Values

Value	Count	Frequency (%)
2015-02-11 20:40:45	5	< 0.1%
2015-02-16 03:51:49	5	< 0.1%
2015-02-01 03:44:13	5	< 0.1%
2015-01-24 03:41:03	5	< 0.1%
2015-02-12 03:14:14	5	< 0.1%
2015-02-05 03:10:31	5	< 0.1%
2015-02-08 04:09:25	5	< 0.1%
2015-02-14 03:21:32	4	< 0.1%
2015-02-06 03:04:54	4	< 0.1%
2015-02-11 03:28:30	4	< 0.1%
Other values (178100)	197374	> 99.9%
(Missing)	7	< 0.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2015-02-07	9079	2.3%
2015-02-15	9011	2.3%
2015-02-14	8916	2.3%
2015-02-08	8898	2.3%
2015-01-24	8149	2.1%
2015-02-16	8147	2.1%
2015-01-31	8107	2.1%
2015-01-25	7774	2.0%
2015-02-01	7651	1.9%
2015-02-13	7362	1.9%
Other values (46108)	311748	79.0%

Most occurring characters

Value	Count	Frequency (%)
0	737718	19.7%
2	591865	15.8%
1	502637	13.4%
-	394842	10.5%
:	394842	10.5%
5	340425	9.1%
	197421	5.3%
3	183671	4.9%
4	156275	4.2%
6	66442	1.8%
Other values (3)	184861	4.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2763894	73.7%
Dash Punctuation	394842	10.5%
Other Punctuation	394842	10.5%
Space Separator	197421	5.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	737718	26.7%
2	591865	21.4%
1	502637	18.2%
5	340425	12.3%
3	183671	6.6%
4	156275	5.7%
6	66442	2.4%
7	63787	2.3%
8	61786	2.2%
9	59288	2.1%

Dash Punctuation

Value	Count	Frequency (%)
-	394842	100.0%

Other Punctuation

Value	Count	Frequency (%)
:	394842	100.0%

Space Separator

Value	Count	Frequency (%)
	197421	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	3750999	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	737718	19.7%
2	591865	15.8%
1	502637	13.4%
-	394842	10.5%
:	394842	10.5%
5	340425	9.1%
	197421	5.3%
3	183671	4.9%
4	156275	4.2%
6	66442	1.8%
Other values (3)	184861	4.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3750999	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	737718	19.7%
2	591865	15.8%
1	502637	13.4%
-	394842	10.5%
:	394842	10.5%
5	340425	9.1%
	197421	5.3%
3	183671	4.9%
4	156275	4.2%
6	66442	1.8%
Other values (3)	184861	4.9%

store_id
Real number (ℝ)

Distinct	6743
Distinct (%)	3.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3530.5103

Minimum	1
Maximum	6987
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.5 MiB

Quantile statistics

Minimum	1
5-th percentile	375
Q1	1686
median	3592
Q3	5299
95-th percentile	6709
Maximum	6987
Range	6986
Interquartile range (IQR)	3613

Descriptive statistics

Standard deviation	2053.4967
Coefficient of variation (CV)	0.58164304
Kurtosis	-1.2421394
Mean	3530.5103
Median Absolute Deviation (MAD)	1813
Skewness	-0.0068077416
Sum	6.9702158 × 10⁸
Variance	4216848.7
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
6865	937	0.5%
1311	863	0.4%
314	815	0.4%
1686	765	0.4%
3937	721	0.4%
6917	668	0.3%
6074	632	0.3%
4367	593	0.3%
3748	560	0.3%
6503	548	0.3%
Other values (6733)	190326	96.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	8	< 0.1%
2	5	< 0.1%
3	3	< 0.1%
4	136	0.1%
5	1	< 0.1%
6	1	< 0.1%
7	19	< 0.1%
8	1	< 0.1%
9	12	< 0.1%
10	2	< 0.1%

Value	Count	Frequency (%)
6987	2	< 0.1%
6986	39	< 0.1%
6985	2	< 0.1%
6984	4	< 0.1%
6983	24	< 0.1%
6982	18	< 0.1%
6981	25	< 0.1%
6980	5	< 0.1%
6979	5	< 0.1%
6977	39	< 0.1%

store_primary_category
Categorical

HIGH CARDINALITY MISSING

Distinct	74
Distinct (%)	< 0.1%
Missing	4760
Missing (%)	2.4%
Memory size	1.5 MiB

american	19399
pizza	17321
mexican	17099
burger	10958
sandwich	10060
Other values (69)	117831

Length

Max length	17
Median length	14
Mean length	6.9550989
Min length	4

Characters and Unicode

Total characters	1340025
Distinct characters	26
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	< 0.1%

Sample

1st row	american
2nd row	mexican
3rd row	indian
4th row	italian
5th row	italian

Common Values

Value	Count	Frequency (%)
american	19399	9.8%
pizza	17321	8.8%
mexican	17099	8.7%
burger	10958	5.6%
sandwich	10060	5.1%
chinese	9421	4.8%
japanese	9196	4.7%
dessert	8773	4.4%
fast	7372	3.7%
indian	7314	3.7%
Other values (64)	75755	38.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
american	19399	10.1%
pizza	17321	9.0%
mexican	17099	8.9%
burger	10958	5.7%
sandwich	10060	5.2%
chinese	9421	4.9%
japanese	9196	4.8%
dessert	8773	4.6%
fast	7372	3.8%
indian	7314	3.8%
Other values (64)	75755	39.3%

Most occurring characters

Value	Count	Frequency (%)
a	208055	15.5%
e	184292	13.8%
i	140842	10.5%
n	120198	9.0%
s	87943	6.6%
r	87208	6.5%
c	66888	5.0%
t	61611	4.6%
m	55053	4.1%
d	42279	3.2%
Other values (16)	285656	21.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1335933	99.7%
Dash Punctuation	4092	0.3%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	208055	15.6%
e	184292	13.8%
i	140842	10.5%
n	120198	9.0%
s	87943	6.6%
r	87208	6.5%
c	66888	5.0%
t	61611	4.6%
m	55053	4.1%
d	42279	3.2%
Other values (15)	281564	21.1%

Dash Punctuation

Value	Count	Frequency (%)
-	4092	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1335933	99.7%
Common	4092	0.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	208055	15.6%
e	184292	13.8%
i	140842	10.5%
n	120198	9.0%
s	87943	6.6%
r	87208	6.5%
c	66888	5.0%
t	61611	4.6%
m	55053	4.1%
d	42279	3.2%
Other values (15)	281564	21.1%

Common

Value	Count	Frequency (%)
-	4092	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1340025	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	208055	15.5%
e	184292	13.8%
i	140842	10.5%
n	120198	9.0%
s	87943	6.6%
r	87208	6.5%
c	66888	5.0%
t	61611	4.6%
m	55053	4.1%
d	42279	3.2%
Other values (16)	285656	21.3%

order_protocol
Real number (ℝ)

Distinct	7
Distinct (%)	< 0.1%
Missing	995
Missing (%)	0.5%
Infinite	0
Infinite (%)	0.0%
Mean	2.8823517

Minimum	1
Maximum	7
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.5 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	3
Q3	4
95-th percentile	5
Maximum	7
Range	6
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	1.5037712
Coefficient of variation (CV)	0.52171676
Kurtosis	-1.3045907
Mean	2.8823517
Median Absolute Deviation (MAD)	2
Skewness	0.13709259
Sum	566189
Variance	2.2613278
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
1	54725	27.7%
3	53199	26.9%
5	44290	22.4%
2	24052	12.2%
4	19354	9.8%
6	794	0.4%
7	19	< 0.1%
(Missing)	995	0.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	54725	27.7%
2	24052	12.2%
3	53199	26.9%
4	19354	9.8%
5	44290	22.4%
6	794	0.4%
7	19	< 0.1%

Value	Count	Frequency (%)
7	19	< 0.1%
6	794	0.4%
5	44290	22.4%
4	19354	9.8%
3	53199	26.9%
2	24052	12.2%
1	54725	27.7%

total_items
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	57
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.1963906

Minimum	1
Maximum	411
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.5 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	3
Q3	4
95-th percentile	7
Maximum	411
Range	410
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	2.6665461
Coefficient of variation (CV)	0.83423662
Kurtosis	2801.4213
Mean	3.1963906
Median Absolute Deviation (MAD)	1
Skewness	21.413824
Sum	631057
Variance	7.1104679
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	55134	27.9%
1	40619	20.6%
3	39253	19.9%
4	25138	12.7%
5	14055	7.1%
6	8618	4.4%
7	5023	2.5%
8	3050	1.5%
9	1861	0.9%
10	1284	0.7%
Other values (47)	3393	1.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	40619	20.6%
2	55134	27.9%
3	39253	19.9%
4	25138	12.7%
5	14055	7.1%
6	8618	4.4%
7	5023	2.5%
8	3050	1.5%
9	1861	0.9%
10	1284	0.7%

Value	Count	Frequency (%)
411	1	< 0.1%
84	1	< 0.1%
66	1	< 0.1%
64	1	< 0.1%
59	1	< 0.1%
57	1	< 0.1%
56	1	< 0.1%
51	1	< 0.1%
50	2	< 0.1%
49	2	< 0.1%

subtotal
Real number (ℝ)

Distinct	8368
Distinct (%)	4.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2682.3314

Minimum	0
Maximum	27100
Zeros	179
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	1.5 MiB

Quantile statistics

Minimum	0
5-th percentile	805
Q1	1400
median	2200
Q3	3395
95-th percentile	6200
Maximum	27100
Range	27100
Interquartile range (IQR)	1995

Descriptive statistics

Standard deviation	1823.0937
Coefficient of variation (CV)	0.67966758
Kurtosis	5.9985775
Mean	2682.3314
Median Absolute Deviation (MAD)	906
Skewness	1.9615013
Sum	5.2956732 × 10⁸
Variance	3323670.6
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1500	961	0.5%
1700	913	0.5%
2000	904	0.5%
1200	887	0.4%
1800	883	0.4%
1600	880	0.4%
1095	877	0.4%
1300	871	0.4%
2200	864	0.4%
1400	852	0.4%
Other values (8358)	188536	95.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	179	0.1%
12	1	< 0.1%
95	1	< 0.1%
100	1	< 0.1%
109	1	< 0.1%
125	1	< 0.1%
139	1	< 0.1%
145	2	< 0.1%
149	3	< 0.1%
152	1	< 0.1%

Value	Count	Frequency (%)
27100	1	< 0.1%
26800	1	< 0.1%
24300	1	< 0.1%
22500	1	< 0.1%
20350	1	< 0.1%
19650	1	< 0.1%
19250	1	< 0.1%
18920	1	< 0.1%
18370	1	< 0.1%
17810	1	< 0.1%

num_distinct_items
Real number (ℝ)

Distinct	20
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.6707914

Minimum	1
Maximum	20
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.5 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	2
Q3	3
95-th percentile	6
Maximum	20
Range	19
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.6302552
Coefficient of variation (CV)	0.61040157
Kurtosis	4.2696206
Mean	2.6707914
Median Absolute Deviation (MAD)	1
Skewness	1.5914791
Sum	527289
Variance	2.6577322
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=20)

Value	Count	Frequency (%)
2	59174	30.0%
1	49839	25.2%
3	41843	21.2%
4	23185	11.7%
5	11772	6.0%
6	5696	2.9%
7	2917	1.5%
8	1419	0.7%
9	734	0.4%
10	389	0.2%
Other values (10)	460	0.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	49839	25.2%
2	59174	30.0%
3	41843	21.2%
4	23185	11.7%
5	11772	6.0%
6	5696	2.9%
7	2917	1.5%
8	1419	0.7%
9	734	0.4%
10	389	0.2%

Value	Count	Frequency (%)
20	1	< 0.1%
19	2	< 0.1%
18	3	< 0.1%
17	2	< 0.1%
16	6	< 0.1%
15	13	< 0.1%
14	35	< 0.1%
13	60	< 0.1%
12	105	0.1%
11	233	0.1%

min_item_price
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	2312
Distinct (%)	1.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	686.21847

Minimum	-86
Maximum	14700
Zeros	2539
Zeros (%)	1.3%
Negative	13
Negative (%)	< 0.1%
Memory size	1.5 MiB

Quantile statistics

Minimum	-86
5-th percentile	125
Q1	299
median	595
Q3	949
95-th percentile	1595
Maximum	14700
Range	14786
Interquartile range (IQR)	650

Descriptive statistics

Standard deviation	522.03865
Coefficient of variation (CV)	0.76074701
Kurtosis	14.602635
Mean	686.21847
Median Absolute Deviation (MAD)	304
Skewness	2.3312796
Sum	1.3547874 × 10⁸
Variance	272524.35
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
795	4197	2.1%
250	4032	2.0%
150	3913	2.0%
200	3863	2.0%
350	3439	1.7%
500	3352	1.7%
300	3317	1.7%
600	3069	1.6%
695	3068	1.6%
495	2852	1.4%
Other values (2302)	162326	82.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-86	1	< 0.1%
-52	1	< 0.1%
-51	1	< 0.1%
-48	1	< 0.1%
-35	1	< 0.1%
-31	1	< 0.1%
-30	1	< 0.1%
-13	2	< 0.1%
-9	1	< 0.1%
-7	1	< 0.1%

Value	Count	Frequency (%)
14700	1	< 0.1%
8999	1	< 0.1%
8959	1	< 0.1%
8415	1	< 0.1%
7999	2	< 0.1%
7500	1	< 0.1%
7475	1	< 0.1%
7398	1	< 0.1%
7299	1	< 0.1%
7259	1	< 0.1%

max_item_price
Real number (ℝ)

Distinct	2652
Distinct (%)	1.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1159.5886

Minimum	0
Maximum	14700
Zeros	7
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	1.5 MiB

Quantile statistics

Minimum	0
5-th percentile	439
Q1	800
median	1095
Q3	1395
95-th percentile	2099
Maximum	14700
Range	14700
Interquartile range (IQR)	595

Descriptive statistics

Standard deviation	558.41138
Coefficient of variation (CV)	0.48155989
Kurtosis	12.915451
Mean	1159.5886
Median Absolute Deviation (MAD)	296
Skewness	2.201033
Sum	2.2893526 × 10⁸
Variance	311823.27
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1095	5648	2.9%
995	5057	2.6%
1195	4349	2.2%
1295	4214	2.1%
999	3858	2.0%
895	3749	1.9%
795	3606	1.8%
799	3405	1.7%
1200	3365	1.7%
1395	3136	1.6%
Other values (2642)	157041	79.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	7	< 0.1%
52	1	< 0.1%
60	1	< 0.1%
75	2	< 0.1%
85	1	< 0.1%
95	3	< 0.1%
99	20	< 0.1%
100	22	< 0.1%
109	51	< 0.1%
110	3	< 0.1%

Value	Count	Frequency (%)
14700	1	< 0.1%
8999	1	< 0.1%
8959	1	< 0.1%
8500	1	< 0.1%
8415	1	< 0.1%
7999	3	< 0.1%
7950	1	< 0.1%
7900	1	< 0.1%
7699	2	< 0.1%
7513	1	< 0.1%

total_onshift_dashers
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	172
Distinct (%)	0.1%
Missing	16262
Missing (%)	8.2%
Infinite	0
Infinite (%)	0.0%
Mean	44.808093

Minimum	-4
Maximum	171
Zeros	3615
Zeros (%)	1.8%
Negative	21
Negative (%)	< 0.1%
Memory size	1.5 MiB

Quantile statistics

Minimum	-4
5-th percentile	4
Q1	17
median	37
Q3	65
95-th percentile	115
Maximum	171
Range	175
Interquartile range (IQR)	48

Descriptive statistics

Standard deviation	34.526783
Coefficient of variation (CV)	0.77054793
Kurtosis	-0.035222417
Mean	44.808093
Median Absolute Deviation (MAD)	23
Skewness	0.8607581
Sum	8117703
Variance	1192.0988
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	3615	1.8%
18	2924	1.5%
15	2912	1.5%
21	2841	1.4%
19	2824	1.4%
10	2756	1.4%
7	2753	1.4%
25	2752	1.4%
9	2752	1.4%
24	2752	1.4%
Other values (162)	152285	77.1%
(Missing)	16262	8.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-4	1	< 0.1%
-3	1	< 0.1%
-2	13	< 0.1%
-1	6	< 0.1%
0	3615	1.8%
1	950	0.5%
2	1622	0.8%
3	2212	1.1%
4	2624	1.3%
5	2607	1.3%

Value	Count	Frequency (%)
171	1	< 0.1%
169	1	< 0.1%
168	1	< 0.1%
165	1	< 0.1%
164	1	< 0.1%
163	1	< 0.1%
162	1	< 0.1%
160	9	< 0.1%
159	1	< 0.1%
158	19	< 0.1%

total_busy_dashers
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	159
Distinct (%)	0.1%
Missing	16262
Missing (%)	8.2%
Infinite	0
Infinite (%)	0.0%
Mean	41.739747

Minimum	-5
Maximum	154
Zeros	4171
Zeros (%)	2.1%
Negative	21
Negative (%)	< 0.1%
Memory size	1.5 MiB

Quantile statistics

Minimum	-5
5-th percentile	3
Q1	15
median	34
Q3	62
95-th percentile	105
Maximum	154
Range	159
Interquartile range (IQR)	47

Descriptive statistics

Standard deviation	32.145733
Coefficient of variation (CV)	0.7701468
Kurtosis	-0.19040114
Mean	41.739747
Median Absolute Deviation (MAD)	22
Skewness	0.78246259
Sum	7561823
Variance	1033.3481
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	4171	2.1%
10	3114	1.6%
13	3052	1.5%
6	3040	1.5%
18	3001	1.5%
11	2981	1.5%
8	2977	1.5%
12	2954	1.5%
16	2935	1.5%
9	2934	1.5%
Other values (149)	150007	76.0%
(Missing)	16262	8.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-5	1	< 0.1%
-4	2	< 0.1%
-3	2	< 0.1%
-2	3	< 0.1%
-1	13	< 0.1%
0	4171	2.1%
1	1596	0.8%
2	2286	1.2%
3	2644	1.3%
4	2841	1.4%

Value	Count	Frequency (%)
154	1	< 0.1%
153	1	< 0.1%
152	2	< 0.1%
150	2	< 0.1%
149	1	< 0.1%
148	31	< 0.1%
147	7	< 0.1%
146	29	< 0.1%
145	36	< 0.1%
144	8	< 0.1%

total_outstanding_orders
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	281
Distinct (%)	0.2%
Missing	16262
Missing (%)	8.2%
Infinite	0
Infinite (%)	0.0%
Mean	58.050065

Minimum	-6
Maximum	285
Zeros	4111
Zeros (%)	2.1%
Negative	44
Negative (%)	< 0.1%
Memory size	1.5 MiB

Quantile statistics

Minimum	-6
5-th percentile	3
Q1	17
median	41
Q3	85
95-th percentile	169
Maximum	285
Range	291
Interquartile range (IQR)	68

Descriptive statistics

Standard deviation	52.66183
Coefficient of variation (CV)	0.90717953
Kurtosis	0.86124431
Mean	58.050065
Median Absolute Deviation (MAD)	29
Skewness	1.1953218
Sum	10516698
Variance	2773.2684
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	4111	2.1%
9	2744	1.4%
10	2705	1.4%
8	2685	1.4%
6	2672	1.4%
7	2621	1.3%
13	2618	1.3%
11	2586	1.3%
18	2566	1.3%
5	2559	1.3%
Other values (271)	153299	77.6%
(Missing)	16262	8.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-6	5	< 0.1%
-5	6	< 0.1%
-4	3	< 0.1%
-3	8	< 0.1%
-2	6	< 0.1%
-1	16	< 0.1%
0	4111	2.1%
1	1511	0.8%
2	2079	1.1%
3	2334	1.2%

Value	Count	Frequency (%)
285	1	< 0.1%
283	1	< 0.1%
278	20	< 0.1%
277	1	< 0.1%
276	35	< 0.1%
274	14	< 0.1%
273	1	< 0.1%
272	33	< 0.1%
270	19	< 0.1%
269	21	< 0.1%

estimated_order_place_duration
Real number (ℝ)

Distinct	98
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	308.56018

Minimum	0
Maximum	2715
Zeros	94
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	1.5 MiB

Quantile statistics

Minimum	0
5-th percentile	251
Q1	251
median	251
Q3	446
95-th percentile	446
Maximum	2715
Range	2715
Interquartile range (IQR)	195

Descriptive statistics

Standard deviation	90.139653
Coefficient of variation (CV)	0.2921299
Kurtosis	4.0715872
Mean	308.56018
Median Absolute Deviation (MAD)	0
Skewness	1.1440917
Sum	60918419
Variance	8125.1571
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
251	139013	70.4%
446	58221	29.5%
0	94	< 0.1%
1487	2	< 0.1%
642	2	< 0.1%
447	2	< 0.1%
1740	2	< 0.1%
521	2	< 0.1%
303	1	< 0.1%
71	1	< 0.1%
Other values (88)	88	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	94	< 0.1%
3	1	< 0.1%
10	1	< 0.1%
12	1	< 0.1%
15	1	< 0.1%
20	1	< 0.1%
32	1	< 0.1%
39	1	< 0.1%
53	1	< 0.1%
54	1	< 0.1%

Value	Count	Frequency (%)
2715	1	< 0.1%
1740	2	< 0.1%
1676	1	< 0.1%
1673	1	< 0.1%
1642	1	< 0.1%
1623	1	< 0.1%
1553	1	< 0.1%
1487	2	< 0.1%
1431	1	< 0.1%
1310	1	< 0.1%

estimated_store_to_consumer_driving_duration
Real number (ℝ)

Distinct	1336
Distinct (%)	0.7%
Missing	526
Missing (%)	0.3%
Infinite	0
Infinite (%)	0.0%
Mean	545.35893

Minimum	0
Maximum	2088
Zeros	9
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	1.5 MiB

Quantile statistics

Minimum	0
5-th percentile	192
Q1	382
median	544
Q3	702
95-th percentile	909
Maximum	2088
Range	2088
Interquartile range (IQR)	320

Descriptive statistics

Standard deviation	219.3529
Coefficient of variation (CV)	0.40221749
Kurtosis	-0.40508768
Mean	545.35893
Median Absolute Deviation (MAD)	160
Skewness	0.1477314
Sum	1.0738226 × 10⁸
Variance	48115.696
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
549	386	0.2%
512	385	0.2%
590	375	0.2%
603	373	0.2%
563	368	0.2%
556	367	0.2%
560	367	0.2%
595	362	0.2%
547	360	0.2%
568	360	0.2%
Other values (1326)	193199	97.9%
(Missing)	526	0.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	9	< 0.1%
1	1	< 0.1%
2	1	< 0.1%
3	6	< 0.1%
4	3	< 0.1%
5	2	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%
10	2	< 0.1%

Value	Count	Frequency (%)
2088	1	< 0.1%
1739	1	< 0.1%
1711	1	< 0.1%
1680	1	< 0.1%
1667	1	< 0.1%
1547	1	< 0.1%
1525	1	< 0.1%
1460	1	< 0.1%
1453	1	< 0.1%
1448	2	< 0.1%

Auto

Heatmap
Table

	market_id	store_id	order_protocol	total_items	subtotal	num_distinct_items	min_item_price	max_item_price	total_onshift_dashers	total_busy_dashers	total_outstanding_orders	estimated_order_place_duration	estimated_store_to_consumer_driving_duration	store_primary_category
market_id	1.000	0.023	-0.012	-0.010	-0.016	-0.000	-0.002	0.002	0.110	0.080	0.078	-0.061	0.009	0.177
store_id	0.023	1.000	0.018	-0.009	-0.015	-0.010	0.001	-0.017	-0.020	-0.020	-0.019	0.017	0.001	0.170
order_protocol	-0.012	0.018	1.000	-0.010	-0.073	-0.025	-0.045	-0.097	0.161	0.164	0.154	-0.708	-0.008	0.319
total_items	-0.010	-0.009	-0.010	1.000	0.664	0.917	-0.591	-0.007	0.057	0.053	0.059	-0.001	0.018	0.021
subtotal	-0.016	-0.015	-0.073	0.664	1.000	0.648	0.027	0.592	0.164	0.160	0.169	0.063	0.041	0.090
num_distinct_items	-0.000	-0.010	-0.025	0.917	0.648	1.000	-0.566	0.079	0.068	0.064	0.071	0.011	0.021	0.078
min_item_price	-0.002	0.001	-0.045	-0.591	0.027	-0.566	1.000	0.430	0.055	0.056	0.057	0.056	0.003	0.106
max_item_price	0.002	-0.017	-0.097	-0.007	0.592	0.079	0.430	1.000	0.168	0.165	0.173	0.087	0.024	0.158
total_onshift_dashers	0.110	-0.020	0.161	0.057	0.164	0.068	0.055	0.168	1.000	0.966	0.957	-0.210	0.052	0.099
total_busy_dashers	0.080	-0.020	0.164	0.053	0.160	0.064	0.056	0.165	0.966	1.000	0.962	-0.212	0.050	0.096
total_outstanding_orders	0.078	-0.019	0.154	0.059	0.169	0.071	0.057	0.173	0.957	0.962	1.000	-0.203	0.049	0.091
estimated_order_place_duration	-0.061	0.017	-0.708	-0.001	0.063	0.011	0.056	0.087	-0.210	-0.212	-0.203	1.000	-0.024	0.100
estimated_store_to_consumer_driving_duration	0.009	0.001	-0.008	0.018	0.041	0.021	0.003	0.024	0.052	0.050	0.049	-0.024	1.000	0.038
store_primary_category	0.177	0.170	0.319	0.021	0.090	0.078	0.106	0.158	0.099	0.096	0.091	0.100	0.038	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	market_id	created_at	actual_delivery_time	store_id	store_primary_category	order_protocol	total_items	subtotal	num_distinct_items	min_item_price	max_item_price	total_onshift_dashers	total_busy_dashers	total_outstanding_orders	estimated_order_place_duration	estimated_store_to_consumer_driving_duration
0	1.0	2015-02-06 22:24:17	2015-02-06 23:27:16	1845	american	1.0	4	3441	4	557	1239	33.0	14.0	21.0	446	861.0
1	2.0	2015-02-10 21:49:25	2015-02-10 22:56:29	5477	mexican	2.0	1	1900	1	1400	1400	1.0	2.0	2.0	446	690.0
2	3.0	2015-01-22 20:39:28	2015-01-22 21:09:09	5477	NaN	1.0	1	1900	1	1900	1900	1.0	0.0	0.0	446	690.0
3	3.0	2015-02-03 21:21:45	2015-02-03 22:13:00	5477	NaN	1.0	6	6900	5	600	1800	1.0	1.0	2.0	446	289.0
4	3.0	2015-02-15 02:40:36	2015-02-15 03:20:26	5477	NaN	1.0	3	3900	3	1100	1600	6.0	6.0	9.0	446	650.0
5	3.0	2015-01-28 20:30:38	2015-01-28 21:08:58	5477	NaN	1.0	3	5000	3	1500	1900	2.0	2.0	2.0	446	338.0
6	3.0	2015-01-31 02:16:36	2015-01-31 02:43:00	5477	NaN	1.0	2	3900	2	1200	2700	10.0	9.0	9.0	446	638.0
7	3.0	2015-02-12 03:03:35	2015-02-12 03:36:20	5477	NaN	1.0	4	4850	4	750	1800	7.0	8.0	7.0	446	626.0
8	2.0	2015-02-16 00:11:35	2015-02-16 00:38:01	5477	indian	3.0	4	4771	3	820	1604	8.0	6.0	18.0	446	289.0
9	3.0	2015-02-18 01:15:45	2015-02-18 02:08:57	5477	NaN	1.0	2	2100	2	700	1200	2.0	2.0	2.0	446	715.0

	market_id	created_at	actual_delivery_time	store_id	store_primary_category	order_protocol	total_items	subtotal	num_distinct_items	min_item_price	max_item_price	total_onshift_dashers	total_busy_dashers	total_outstanding_orders	estimated_order_place_duration	estimated_store_to_consumer_driving_duration
197418	1.0	2015-01-30 20:50:23	2015-01-30 22:24:38	2956	fast	4.0	2	1528	2	639	729	26.0	29.0	34.0	251	791.0
197419	1.0	2015-01-26 21:25:12	2015-01-26 22:21:22	2956	fast	4.0	1	809	1	729	729	20.0	18.0	18.0	251	818.0
197420	2.0	2015-02-18 02:16:04	2015-02-18 03:12:36	2956	indian	3.0	3	2352	3	499	685	49.0	49.0	65.0	251	560.0
197421	1.0	2015-01-30 03:35:01	2015-01-30 04:42:19	2956	fast	4.0	2	979	2	145	339	NaN	NaN	NaN	251	614.0
197422	1.0	2015-01-31 19:48:15	2015-01-31 20:27:39	2956	fast	4.0	7	2445	3	145	585	23.0	24.0	24.0	251	608.0
197423	1.0	2015-02-17 00:19:41	2015-02-17 01:24:48	2956	fast	4.0	3	1389	3	345	649	17.0	17.0	23.0	251	331.0
197424	1.0	2015-02-13 00:01:59	2015-02-13 00:58:22	2956	fast	4.0	6	3010	4	405	825	12.0	11.0	14.0	251	915.0
197425	1.0	2015-01-24 04:46:08	2015-01-24 05:36:16	2956	fast	4.0	5	1836	3	300	399	39.0	41.0	40.0	251	795.0
197426	1.0	2015-02-01 18:18:15	2015-02-01 19:23:22	3630	sandwich	1.0	1	1175	1	535	535	7.0	7.0	12.0	446	384.0
197427	1.0	2015-02-08 19:24:33	2015-02-08 20:01:41	3630	sandwich	1.0	4	2605	4	425	750	20.0	20.0	23.0	446	134.0

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Dash Punctuation

Other Punctuation

Space Separator

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Dash Punctuation

Other Punctuation

Space Separator

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Missing values

Sample